package com.dao.impl;


import org.springframework.stereotype.Repository;

import com.dao.IBisLayotDao;
import com.model.Bis_layot;

@Repository
public class BisLayotHibernateDao extends
		GenericHibernateDao<Bis_layot, String> implements IBisLayotDao {

	public Bis_layot getLayoutByWo(String wo_id) {

		String sql = "FROM Bis_layot where layot_id IN ("
				+ " SELECT layot_id_fk FROM Bis_mdl_def WHERE mdl_id IN ("
				+ " SELECT mdl_id_fk FROM Ret_wo WHERE wo_id='" + wo_id + "')"
				+ " )";

		Bis_layot bis_layot = (Bis_layot) this.comTblRead(sql);
		return bis_layot;
	}

}
